Todd Aldrich ✭✭✭

• Activity
• Discussions4
• Comments4

• Collect and HAS Functions

  Todd Aldrich

  08/16/21
  I need to find the average dollar amount across a range only if the fiscal year IS 2018 and a multiselect column HAS a given value =AVG(COLLECT([Funding Amount]:[Funding Amount], Subsector:Subsector,…
  1 ·